import openpyxl
class ReadExcel:

    @staticmethod
    def read_excel(file_path,sheet_name):
        workbook=openpyxl.load_workbook(file_path)
        sheet=workbook[sheet_name]
        data=[[sheet.cell(row=i,column=j).value for j in range(1,sheet.max_column+1)] for i in range(2,sheet.max_row+1)]
        return data



if __name__=="__main__":

    print(ReadExcel.read_excel('./bookstore.xlsx','订单明细表'))